PostgreSQL passworkcheck 扩展创建失败

1 报错信息

CREATE EXTENSION passwordcheck;
ERROR:  could not open extension control file "/usr/local/pg12/share/postgresql/extension/passwordcheck.control": No such file or directory

2 问题原因

1、编译passwordcheck 插件后，创建插件无法创建，没有 passwordcheck.control 文件，这里需要手动创建。

3 解决方法

4 创建 passwordcheck.control 和 passwordcheck--1.0.sql 文件

su - postgres
cd $PGHOME/share/postgresql/extension
cat >>  passwordcheck.control << EOF
# spasswordcheck extension
comment = 'postgres user password Check'
default_version = '1.0'
module_pathname = '$libdir/passwordcheck'
relocatable = false
schema = passwordcheck
EOF
touch passwordcheck--1.0.sql 

4.1 创建成功

CREATE EXTENSION passwordcheck;

参考链接
创建扩展passwordcheck失败：No such file or directory_10920585的技术博客_51CTO博客